Tables [dbo].[ReceiptTypeRef]
Properties
PropertyValue
Created10:31:36 AM Tuesday, March 02, 2010
Last Modified11:40:07 AM Monday, February 20, 2012
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ReceiptTypeRef: ReceiptTypeKeyReceiptTypeKeyuniqueidentifier16
No
Indexes AK_ReceiptTypeRef_ReceiptTypeDesc: ReceiptTypeDescReceiptTypeDescnvarchar(200)400
No
ReceiptTitlenvarchar(200)400
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_ReceiptTypeRef: ReceiptTypeKeyPK_ReceiptTypeRefReceiptTypeKey
Yes
AK_ReceiptTypeRef_ReceiptTypeDescReceiptTypeDesc
Yes
SQL Script
CREATE TABLE [dbo].[ReceiptTypeRef]
(
[ReceiptTypeKey] [uniqueidentifier] NOT NULL,
[ReceiptTypeDesc] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReceiptTitle] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ReceiptTypeRef] ADD CONSTRAINT [PK_ReceiptTypeRef] PRIMARY KEY CLUSTERED ([ReceiptTypeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReceiptTypeRef] ADD CONSTRAINT [AK_ReceiptTypeRef_ReceiptTypeDesc] UNIQUE NONCLUSTERED ([ReceiptTypeDesc]) ON [PRIMARY]
GO
Uses
Used By